{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}/Users/sebastiantonke/Desktop/Replication Package/Replication files experiment/output_logs/table 1.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}20 Jul 2023, 09:21:45
{txt}
{com}. 
. estpost tabstat paymentw paymentcondw invoicesw prepaidcounttotal preclosingbalancew preage_of_accountw if t<=12, by(itt) statistics(mean p25 med p75 sd count) columns(statistics) nototal

{txt}Summary statistics: mean p25 p50 p75 sd count
     for variables: paymentw paymentcondw invoicesw prepaidcounttotal preclosingbalancew preage_of_accountw
  by categories of: itt

{space 0}{space 0}{ralign 12:itt}{space 1}{c |}{space 1}{ralign 9:e(mean)}{space 1}{space 1}{ralign 9:e(p25)}{space 1}{space 1}{ralign 9:e(p50)}{space 1}{space 1}{ralign 9:e(p75)}{space 1}{space 1}{ralign 9:e(sd)}{space 1}{space 1}{ralign 9:e(count)}{space 1}
{space 0}{hline 13}{c   +}{hline 11}{hline 11}{hline 11}{hline 11}{hline 11}{hline 11}
{space 0}{res:{lalign 13:0}}{c |}{space 11}{space 11}{space 11}{space 11}{space 11}{space 11}
{space 0}{space 0}{ralign 12:paymentw}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 100.1607}}}{space 1}{space 1}{ralign 9:{res:{sf:        0}}}{space 1}{space 1}{ralign 9:{res:{sf:        0}}}{space 1}{space 1}{ralign 9:{res:{sf:      100}}}{space 1}{space 1}{ralign 9:{res:{sf: 237.2993}}}{space 1}{space 1}{ralign 9:{res:{sf:    36394}}}{space 1}
{space 0}{space 0}{ralign 12:paymentcondw}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 292.9806}}}{space 1}{space 1}{ralign 9:{res:{sf:       81}}}{space 1}{space 1}{ralign 9:{res:{sf:      158}}}{space 1}{space 1}{ralign 9:{res:{sf:      315}}}{space 1}{space 1}{ralign 9:{res:{sf: 378.0584}}}{space 1}{space 1}{ralign 9:{res:{sf:    13002}}}{space 1}
{space 0}{space 0}{ralign 12:invoicesw}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 125.4852}}}{space 1}{space 1}{ralign 9:{res:{sf:     21.2}}}{space 1}{space 1}{ralign 9:{res:{sf:     53.7}}}{space 1}{space 1}{ralign 9:{res:{sf:    119.4}}}{space 1}{space 1}{ralign 9:{res:{sf: 228.3806}}}{space 1}{space 1}{ralign 9:{res:{sf:    36394}}}{space 1}
{space 0}{space 0}{ralign 12:prepaidcou~l}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 4.149145}}}{space 1}{space 1}{ralign 9:{res:{sf:        2}}}{space 1}{space 1}{ralign 9:{res:{sf:        4}}}{space 1}{space 1}{ralign 9:{res:{sf:        6}}}{space 1}{space 1}{ralign 9:{res:{sf: 2.754684}}}{space 1}{space 1}{ralign 9:{res:{sf:    36394}}}{space 1}
{space 0}{space 0}{ralign 12:preclosing~w}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 510.3556}}}{space 1}{space 1}{ralign 9:{res:{sf:    31.95}}}{space 1}{space 1}{ralign 9:{res:{sf:   138.55}}}{space 1}{space 1}{ralign 9:{res:{sf:   456.67}}}{space 1}{space 1}{ralign 9:{res:{sf: 1274.773}}}{space 1}{space 1}{ralign 9:{res:{sf:    36394}}}{space 1}
{space 0}{space 0}{ralign 12:preage_of_~w}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 44.29741}}}{space 1}{space 1}{ralign 9:{res:{sf:       19}}}{space 1}{space 1}{ralign 9:{res:{sf:       34}}}{space 1}{space 1}{ralign 9:{res:{sf:       53}}}{space 1}{space 1}{ralign 9:{res:{sf: 39.21726}}}{space 1}{space 1}{ralign 9:{res:{sf:    36394}}}{space 1}
{space 0}{hline 13}{c   +}{hline 11}{hline 11}{hline 11}{hline 11}{hline 11}{hline 11}
{space 0}{res:{lalign 13:1}}{c |}{space 11}{space 11}{space 11}{space 11}{space 11}{space 11}
{space 0}{space 0}{ralign 12:paymentw}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 100.0715}}}{space 1}{space 1}{ralign 9:{res:{sf:        0}}}{space 1}{space 1}{ralign 9:{res:{sf:        0}}}{space 1}{space 1}{ralign 9:{res:{sf:      100}}}{space 1}{space 1}{ralign 9:{res:{sf: 237.0211}}}{space 1}{space 1}{ralign 9:{res:{sf:    36756}}}{space 1}
{space 0}{space 0}{ralign 12:paymentcondw}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 292.7782}}}{space 1}{space 1}{ralign 9:{res:{sf:       85}}}{space 1}{space 1}{ralign 9:{res:{sf:      156}}}{space 1}{space 1}{ralign 9:{res:{sf:      301}}}{space 1}{space 1}{ralign 9:{res:{sf: 381.8161}}}{space 1}{space 1}{ralign 9:{res:{sf:    13178}}}{space 1}
{space 0}{space 0}{ralign 12:invoicesw}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 123.1506}}}{space 1}{space 1}{ralign 9:{res:{sf:     26.7}}}{space 1}{space 1}{ralign 9:{res:{sf:     53.7}}}{space 1}{space 1}{ralign 9:{res:{sf:    115.7}}}{space 1}{space 1}{ralign 9:{res:{sf:  223.921}}}{space 1}{space 1}{ralign 9:{res:{sf:    36756}}}{space 1}
{space 0}{space 0}{ralign 12:prepaidcou~l}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 4.177141}}}{space 1}{space 1}{ralign 9:{res:{sf:        2}}}{space 1}{space 1}{ralign 9:{res:{sf:        4}}}{space 1}{space 1}{ralign 9:{res:{sf:        6}}}{space 1}{space 1}{ralign 9:{res:{sf: 2.688395}}}{space 1}{space 1}{ralign 9:{res:{sf:    36756}}}{space 1}
{space 0}{space 0}{ralign 12:preclosing~w}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 466.6838}}}{space 1}{space 1}{ralign 9:{res:{sf:    37.27}}}{space 1}{space 1}{ralign 9:{res:{sf:   125.61}}}{space 1}{space 1}{ralign 9:{res:{sf:   406.75}}}{space 1}{space 1}{ralign 9:{res:{sf: 1203.756}}}{space 1}{space 1}{ralign 9:{res:{sf:    36756}}}{space 1}
{space 0}{space 0}{ralign 12:preage_of_~w}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 45.36742}}}{space 1}{space 1}{ralign 9:{res:{sf:       19}}}{space 1}{space 1}{ralign 9:{res:{sf:       34}}}{space 1}{space 1}{ralign 9:{res:{sf:       55}}}{space 1}{space 1}{ralign 9:{res:{sf: 39.69976}}}{space 1}{space 1}{ralign 9:{res:{sf:    36756}}}{space 1}
{space 0}{hline 13}{c   +}{hline 11}{hline 11}{hline 11}{hline 11}{hline 11}{hline 11}
{space 0}{res:{lalign 13:2}}{c |}{space 11}{space 11}{space 11}{space 11}{space 11}{space 11}
{space 0}{space 0}{ralign 12:paymentw}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 99.76866}}}{space 1}{space 1}{ralign 9:{res:{sf:        0}}}{space 1}{space 1}{ralign 9:{res:{sf:        0}}}{space 1}{space 1}{ralign 9:{res:{sf:      100}}}{space 1}{space 1}{ralign 9:{res:{sf: 237.6372}}}{space 1}{space 1}{ralign 9:{res:{sf:    36094}}}{space 1}
{space 0}{space 0}{ralign 12:paymentcondw}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 292.0278}}}{space 1}{space 1}{ralign 9:{res:{sf:       80}}}{space 1}{space 1}{ralign 9:{res:{sf:    155.5}}}{space 1}{space 1}{ralign 9:{res:{sf:      300}}}{space 1}{space 1}{ralign 9:{res:{sf: 379.4713}}}{space 1}{space 1}{ralign 9:{res:{sf:    12892}}}{space 1}
{space 0}{space 0}{ralign 12:invoicesw}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 124.3058}}}{space 1}{space 1}{ralign 9:{res:{sf:    21.66}}}{space 1}{space 1}{ralign 9:{res:{sf:    50.75}}}{space 1}{space 1}{ralign 9:{res:{sf:   111.65}}}{space 1}{space 1}{ralign 9:{res:{sf: 227.8641}}}{space 1}{space 1}{ralign 9:{res:{sf:    36094}}}{space 1}
{space 0}{space 0}{ralign 12:prepaidcou~l}{space 1}{c |}{space 1}{ralign 9:{res:{sf:  4.14997}}}{space 1}{space 1}{ralign 9:{res:{sf:        2}}}{space 1}{space 1}{ralign 9:{res:{sf:        4}}}{space 1}{space 1}{ralign 9:{res:{sf:        6}}}{space 1}{space 1}{ralign 9:{res:{sf: 2.695313}}}{space 1}{space 1}{ralign 9:{res:{sf:    36094}}}{space 1}
{space 0}{space 0}{ralign 12:preclosing~w}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 495.5887}}}{space 1}{space 1}{ralign 9:{res:{sf:    31.65}}}{space 1}{space 1}{ralign 9:{res:{sf:   127.33}}}{space 1}{space 1}{ralign 9:{res:{sf:   417.36}}}{space 1}{space 1}{ralign 9:{res:{sf: 1334.251}}}{space 1}{space 1}{ralign 9:{res:{sf:    36094}}}{space 1}
{space 0}{space 0}{ralign 12:preage_of_~w}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 45.10955}}}{space 1}{space 1}{ralign 9:{res:{sf:       19}}}{space 1}{space 1}{ralign 9:{res:{sf:       34}}}{space 1}{space 1}{ralign 9:{res:{sf:       55}}}{space 1}{space 1}{ralign 9:{res:{sf:  39.6129}}}{space 1}{space 1}{ralign 9:{res:{sf:    36094}}}{space 1}

{com}. 
. * Checking for balance *
. foreach x in paymentw paymentcondw invoicesw prepaidcounttotal preclosingbalancew preage_of_accountw {c -(}
{txt}  2{com}. reg `x' i.itt if itt!=. & t<=12, vce(cluster customer)
{txt}  3{com}. {c )-}

{txt}Linear regression                               Number of obs     = {res}   109,244
                                                {txt}F(2, 9875)        =  {res}     0.01
                                                {txt}Prob > F          = {res}    0.9865
                                                {txt}R-squared         = {res}    0.0000
                                                {txt}Root MSE          =    {res} 237.32

{txt}{ralign 78:(Std. Err. adjusted for {res:9,876} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}    paymentw{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2}-.0891413{col 26}{space 2}  2.46535{col 37}{space 1}   -0.04{col 46}{space 3}0.971{col 54}{space 4}-4.921732{col 67}{space 3} 4.743449
{txt}{space 10}2  {c |}{col 14}{res}{space 2}-.3920245{col 26}{space 2} 2.483136{col 37}{space 1}   -0.16{col 46}{space 3}0.875{col 54}{space 4}-5.259479{col 67}{space 3}  4.47543
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 100.1607{col 26}{space 2}  1.74138{col 37}{space 1}   57.52{col 46}{space 3}0.000{col 54}{space 4} 96.74722{col 67}{space 3} 103.5741
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}    39,072
                                                {txt}F(2, 9143)        =  {res}     0.01
                                                {txt}Prob > F          = {res}    0.9918
                                                {txt}R-squared         = {res}    0.0000
                                                {txt}Root MSE          =    {res}  379.8

{txt}{ralign 78:(Std. Err. adjusted for {res:9,144} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}paymentcondw{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2}-.2024075{col 26}{space 2} 7.816176{col 37}{space 1}   -0.03{col 46}{space 3}0.979{col 54}{space 4}-15.52386{col 67}{space 3} 15.11904
{txt}{space 10}2  {c |}{col 14}{res}{space 2}-.9527833{col 26}{space 2} 7.827133{col 37}{space 1}   -0.12{col 46}{space 3}0.903{col 54}{space 4}-16.29571{col 67}{space 3} 14.39015
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 292.9806{col 26}{space 2} 5.540301{col 37}{space 1}   52.88{col 46}{space 3}0.000{col 54}{space 4} 282.1204{col 67}{space 3} 303.8408
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}   109,244
                                                {txt}F(2, 9875)        =  {res}     0.27
                                                {txt}Prob > F          = {res}    0.7630
                                                {txt}R-squared         = {res}    0.0000
                                                {txt}Root MSE          =    {res} 226.72

{txt}{ralign 78:(Std. Err. adjusted for {res:9,876} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}   invoicesw{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2}-2.334623{col 26}{space 2} 3.174244{col 37}{space 1}   -0.74{col 46}{space 3}0.462{col 54}{space 4}-8.556789{col 67}{space 3} 3.887543
{txt}{space 10}2  {c |}{col 14}{res}{space 2}-1.179462{col 26}{space 2} 3.258716{col 37}{space 1}   -0.36{col 46}{space 3}0.717{col 54}{space 4} -7.56721{col 67}{space 3} 5.208287
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 125.4852{col 26}{space 2} 2.247674{col 37}{space 1}   55.83{col 46}{space 3}0.000{col 54}{space 4} 121.0793{col 67}{space 3} 129.8911
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}   109,244
                                                {txt}F(2, 9875)        =  {res}     0.11
                                                {txt}Prob > F          = {res}    0.8962
                                                {txt}R-squared         = {res}    0.0000
                                                {txt}Root MSE          =    {res} 2.7129

{txt}{ralign 78:(Std. Err. adjusted for {res:9,876} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}prepaidcou~l{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2} .0279957{col 26}{space 2} .0685738{col 37}{space 1}    0.41{col 46}{space 3}0.683{col 54}{space 4} -.106423{col 67}{space 3} .1624143
{txt}{space 10}2  {c |}{col 14}{res}{space 2} .0008241{col 26}{space 2} .0689653{col 37}{space 1}    0.01{col 46}{space 3}0.990{col 54}{space 4}-.1343621{col 67}{space 3} .1360102
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 4.149145{col 26}{space 2} .0491771{col 37}{space 1}   84.37{col 46}{space 3}0.000{col 54}{space 4} 4.052748{col 67}{space 3} 4.245543
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}   109,244
                                                {txt}F(2, 9875)        =  {res}     1.01
                                                {txt}Prob > F          = {res}    0.3654
                                                {txt}R-squared         = {res}    0.0002
                                                {txt}Root MSE          =    {res} 1271.7

{txt}{ralign 78:(Std. Err. adjusted for {res:9,876} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}preclosing~w{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2}-43.67178{col 26}{space 2} 31.44967{col 37}{space 1}   -1.39{col 46}{space 3}0.165{col 54}{space 4}-105.3196{col 67}{space 3} 17.97601
{txt}{space 10}2  {c |}{col 14}{res}{space 2}-14.76688{col 26}{space 2} 33.23613{col 37}{space 1}   -0.44{col 46}{space 3}0.657{col 54}{space 4}-79.91649{col 67}{space 3} 50.38272
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 510.3556{col 26}{space 2} 22.90493{col 37}{space 1}   22.28{col 46}{space 3}0.000{col 54}{space 4} 465.4573{col 67}{space 3} 555.2539
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}   109,244
                                                {txt}F(2, 9875)        =  {res}     0.63
                                                {txt}Prob > F          = {res}    0.5311
                                                {txt}R-squared         = {res}    0.0001
                                                {txt}Root MSE          =    {res} 39.511

{txt}{ralign 78:(Std. Err. adjusted for {res:9,876} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}preage_of_~w{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2} 1.070011{col 26}{space 2} .9933432{col 37}{space 1}    1.08{col 46}{space 3}0.281{col 54}{space 4}-.8771442{col 67}{space 3} 3.017167
{txt}{space 10}2  {c |}{col 14}{res}{space 2} .8121356{col 26}{space 2} .9970438{col 37}{space 1}    0.81{col 46}{space 3}0.415{col 54}{space 4}-1.142274{col 67}{space 3} 2.766545
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 44.29741{col 26}{space 2} .6996593{col 37}{space 1}   63.31{col 46}{space 3}0.000{col 54}{space 4} 42.92594{col 67}{space 3} 45.66889
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}{txt}
{com}. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}/Users/sebastiantonke/Desktop/Replication Package/Replication files experiment/output_logs/table 1.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}20 Jul 2023, 09:21:48
{txt}{.-}
{smcl}
{txt}{sf}{ul off}